package com.kb.design.mapper.postgreSQL;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kb.design.entity.ProjectQaValue;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ProjectQaValueMapper extends BaseMapper<ProjectQaValue> {
    // 可以在这里添加自定义的SQL方法
    @Select("SELECT role_key FROM project_qa_value WHERE project_id = #{projectId} GROUP BY role_key")
    List<String> roleStr(Long projectId);
}
